<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateOrderStatementsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {   //订单报表
        Schema::create('order_statements', function (Blueprint $table) {
            $table->increments('id');
            //订单编号
            $table->string('order_num')->nullable();
            //买家会员名
            $table->string('buyer_member_name')->nullable();
            //买家支付宝账号
            $table->string('buyer_alipay')->nullable();
            //买家应付货款
            $table->string('buyer_due_money')->nullable();
            //买家应付邮费
            $table->string('buyer_due_postage')->nullable();
            //买家支付积分
            $table->string('buyer_pay_point')->nullable();
            //总金额
            $table->string('total_money')->nullable();
            //返点积分
            $table->string('rebate_point')->nullable();
            //买家实际支付金额
            $table->string('buyer_actually_pay_money')->nullable();
            //买家实际支付积分
            $table->string('buyer_actually_pay_point')->nullable();
            //订单状态
            $table->string('order_status')->nullable();
            //买家留言
            $table->string('buyer_leave_word')->nullable();
            //收货人姓名
            $table->string('recipients_name')->nullable();
            //收货人地址
            $table->string('recipients_address')->nullable();
            //运送方式
            $table->string('transport_way')->nullable();
            //联系电话
            $table->string('contact_phone')->nullable();
            //联系手机
            $table->string('contact_mobile')->nullable();
            //订单创建时间
            $table->string('order_created_at')->nullable();
            //订单付款时间
            $table->string('order_paid_at')->nullable();
            //宝贝标题
            $table->string('commodity_title')->nullable();
            //宝贝种类
            $table->string('commodity_classification')->nullable();
            //物流单号
            $table->string('logistics_num')->nullable();
            //物流公司
            $table->string('logistics_company')->nullable();
            //订单备注
            $table->string('order_comment')->nullable();
            //宝贝总数量
            $table->string('commodity_total_quantity')->nullable();
            //店铺 id
            $table->string('shop_id')->nullable();
            //店铺名称
            $table->string('shop_name')->nullable();
            //订单关闭原因
            $table->string('order_closure_reason')->nullable();
            //卖家服务费
            $table->string('seller_service_charge')->nullable();
            //买家服务费
            $table->string('buyer_service_charge')->nullable();
            //发票抬头
            $table->string('invoice_title')->nullable();
            //是否手机订单
            $table->string('is_mobile_order')->nullable();
            //分阶段订单信息
            $table->string('grading_order_message')->nullable();
            //特权订金订单id
            $table->string('prerogative_subscription_order_id')->nullable();
            //定金排名
            $table->string('subscription_ranking')->nullable();
            //修改后的sku
            $table->string('modified_sku')->nullable();
            //修改后的收货地址
            $table->string('modified_receiver_address')->nullable();
            //异常信息
            $table->string('exception_message')->nullable();
            //天猫卡券抵扣
            $table->string('tmall_card_deduction')->nullable();
            //集分宝抵扣
            $table->string('jifenbao_deduction')->nullable();
            //是否是O2O交易
            $table->string('is_o2o_trade')->nullable();
            // $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('order_statements');
    }
}
